Oracle Utilities Customer Care and Billing Configuration GL Integration Point To enable this integration point you must configure the following information in Oracle Utilities Customer Care and Billing. Configuring GL Division If you decide to integrate the financial transactions for a specific GL Division in Oracle Utilities Customer Care and Billing to E-Business Suite, identify the GL Division. Configuring Distribution Codes You must map your distribution codes in Oracle Utilities Customer Care and Billing with the appropriate GL Accounts in the Oracle E-Business Suite Revenue Accounting GL. First configure the distribution codes and then assign them to various entities within the Oracle Utilities Customer Care and Billing applications. Oracle Applications GL accounts are structured using account segments. These are set up in your existing Oracle E-Business Suite Revenue Accounting system according to your business practices. Oracle Utilities Customer Care and Billing distribution codes must be configured to mirror the segments & Values in Oracle E-Business Suite Revenue Accounting. The segment positions are fixed in Customer Care and Billing so that the first segment is Account, the second segment is Department ID, and so on, as shown in the following table. Oracle E-Business Suite Revenue Accounting Account Column name Oracle Utilities Customer Care and Billing Distribution (GL_ACCT) segment position Company Position1 Department Position2 Account Position3 Sub-Account Position4 Product Position5 A sample GL Account string is 01-520-5250-0000-000. When interpreted by the standard mapping in the product this GL Account String in the sub ledger equates to the following in the Oracle Applications GL. When interpreted by the standard mapping in the product this GL Account String in the sub ledger equates to the following in the Oracle JD Edwards EnterpriseOne Financial Management GL: • Company - 01 • Department - 520 • Account -5250 • Sub-Account - 0000 • Product -000 Note: Only fields relevant to the integration are included in this table. Field Label Value Comment Distribution Code Example: R - ELERES The distribution code to be used for financial transactions of a certain type. Description Example: Revenue - Electric - Residential A description of how the distribution code is used. GL Account Algorithm C1-GLCNSTR-D The standard product or customer modified algorithm you use for determining the GL Account String from the distribution code. GL Account Details 1 of 1 Create at least one set of account details as needed by your chosen algorithm above. Only one will be used based on status and effective date. Effective Date 01-01-1900 The date you wish the following GL Account string to become active and used by the system, and therefore the integration software. Status Active Only active status accounts will be used by the product and therefore the integration. GL Account 01-520-5250-0000-000 Input the GL Account String as explained above. Configuring GLASSIGN, and GLS for Oracle Utilities Customer Care and Billing Extract To successfully execute extracts from Oracle Utilities Customer Care and Billing, two processes must be configured with the appropriate batch parameters and set to run on a scheduled basis. These processes can be scheduled using the Oracle Utilities Customer Care and Billing scheduling tool or an enterprise scheduler that meets the open architecture standards used by Oracle Utilities Customer Care and Billing.